Group by dimension

[markgraham123]

Hi all,

I was struck at a basic 'if expression' which should separate the Categories based on ID and Name.

ID,	Name,	Type
abcd,	123,	A
abcd,	456,	B
efgh,	789,	A
ijkl,	1011,	B
mnop,	1213,	A
qrst,	1415,	B

Here i want to create two new fields ID Category and Name Category which will differentiate it's own types - A and B.

any help is highly appreciated.

Please find the attachment.

[Colin-Albert]

Can you give an example of what the expected output for ID Category and Name Category should be?

[Mark_Little]

Hi,

Can you supply some more information?

How are you defining the two new fields?

Even if you just stated in English would be helpful.

Mark

[markgraham123]

Hi Colin,

The ID Category and Name Category should have the flags A, B.

Such that, We can differentiate the categories by ID and Name level.

[harsh44_bhatia]

Hi,

Can you state with eg, how you want to create the two ID columns

[Colin-Albert]

Doesn't the Type field already do that?

[Mark_Little]

Hi,

Yer I am think the same as Colin, sure just selections on the Category or even just the type column does that already?

Mark

[markgraham123]

Colin,

I should have been clear enough.

Let me repost the question and attachment.

[Colin-Albert]

Just rename the Type field to Category in the load

Table1:

LOAD

     ID,

     Name,

     Type as Category

Inline

[

ID,     Name, Type

abcd, 123, A

abcd, 456, B

efgh, 789, A

ijkl,     1011,     B

mnop, 1213, A

qrst, 1415, B

]

;