I have created a document using where not exists to get distinct categories of records. But it creates 3 field.
Can someone please help me create all three categories in a single field instead of three individual fields?
Any help is highly appreciated.
Current situation: Catogory A, B, and C are in differernt fields,
It woul dbe great to see it in a single field.
Not sure if I understand your requirement correctly, but yes, the input table needs to be sorted properly to make this approach work. If your sort order is a little uncommon (i.e. default ORDER BY FIELD ASC/DESC does not work), you may need to map a sort order to Category and sort by this field.
How do you want your final table to look like? Currently it looks like this after your reload
What do you expect to see differently in the above image?
This is what I'm exactyl looking for Sunny.
But as @stefanWuhl mentioned, can't we just use Not Exists (SKU) in the where statement?
To make my script work, you shouldn't load SKU field before running my table load.
I think you know how exists() work? Checking an input value against a symbol table containing all field values encountered so far in your load script run?