create a single field of values using Not Exists

[markgraham123]

Hi,

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.

Thanks!

[sunny_talwar]

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?

[markgraham123]

Req. O/P:

Category SKU

A             1

A             2

A             3

B             4

C             5

[swuehl]

Just this?

Table1:

LOAD * Inline

[

SKU, Category

1, A

1, B

1, C

2, A

2, B

3, A

3, B

3, C

4, B

5, C

]  WHERE NOT EXISTS(SKU);

[sunny_talwar]

May be like attached

[markgraham123]

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?

[sunny_talwar]

Have you tried Stefan's script? It isn't working?

[markgraham123]

Sunny,

I just tried the same in original req. it didn't work.

Sorry for the confusion

[markgraham123]

Stefan,

     It is not working. Let me put the result what i'm seeing.

[swuehl]

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?