Resident Table Queries

[Saravanan_Desingh]

I just noticed, I could not use the below syntax

RawData:

Load * Resident PreData;

To make this work, I have to trick it as follow,

Load *, 'X' Resident PreData;

Is there any reason for this?

Also I could not see Resident Table structure in the Table Viewer. So, I could not see the preview of the Resident Tables.

[sunny_talwar]

You can use this:

RawData:

NoConcatenate

Load *

Resident PreData;

The reason being, when there are two tables with the same fields (exact same fieldnames), QlikView Auto-Concatenate them unless you tell it otherwise (using NoConcatenate)

[Saravanan_Desingh]

Working now. Thanks Sunny

[sunny_talwar]

You marked your own response as 'HELPFUL' . I guess I was not that helpful