Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can you give an example of what the expected output for ID Category and Name Category should be?
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
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.
Hi,
Can you state with eg, how you want to create the two ID columns
Doesn't the Type field already do that?
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
Colin,
I should have been clear enough.
Let me repost the question and attachment.
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
]
;