Ungroup Collection - Column Already Exists

[shdfbasfgagfkay]

In my code, Ungroup keeps showing error that a column already exists (I know that it will error to avoid duplicate columns). But I didn't see that particular column in collection structure (under View>Collections). So I thought of dropping the column first just to check, but then DropCoulmns says it can't find that column!

Screen-shots below showing the two errors:

(The variable 'xc2' is just for testing.) I want to ungroup 'Choices' but it shows error saying one of the columns - 'ChoiceCond1' - in 'Choices' group already exists. I was sure it doesn't but to verify I added DropColumns to see if it really does. In second screen-shot, the DropColumns complains that the 'ChoiceCond1' doesn't exists.

I'm at loss here, what am I missing?

Here the Upgroup says 'ChoiceCond1' already exists so it can't ungroup

Here DropColumns says the 'ChoiceCond1' column doesn't exist

Any help would be appreciated.

[RandyHayes]

@shdfbasfgagfkay 

What is the structure of your collection?

[shdfbasfgagfkay]

Collection has lots of columns, but out of those two are grouped - Choices and Answers. Partial structure below (unless you need to see a complete one):

Columns	Subcolumns
TagNo
TaskNo
SubSys
StepSeq
StepNo
StepText
Choices	ChoiceID
	ChoiceRN
	ChoiceLabel
	ChoiceSuffix
	ChoiceResponse
	ChoiceUpdated
	ChoiceCond1
	hChoiceResponse
ChoiceReqdMin
ChoiceReqdMax
Answers	AnswerID
	AnswerRN
	AnswerLabel
	AnswerSuffix
	AnswerResponse
	AnswerUpdated
	AnswerCond1
	hChoiceResponse
AnswerReqdMin
AnswerReqdMax
StepComment
StepUserID
StepUserInitials
StepTimestamp

[RandyHayes]

@shdfbasfgagfkay 

Okay, but in your formula you are trying to ungroup by ChoiceCond1 - which is a column of a Choices table.  That is not going to work.

What is it that you are trying to achieve?  What is the structure of the data that you want from your Ungroup?

[shdfbasfgagfkay]

If you look closely it's 'Choices' column that I'm ungrouping. ('ChoiceCond1' is argument in the DropColumns).

I'm bringing data from SQL (has comma separated choices in columns), splitting those into nested table, user modifies the data thru the app, concatenating back, and sending to SQL.