Loading Data And Designing

[nani1618]

Hi All,

I am loading 3 different QVDS  from same source with same field names but the data is different and I want to separate that date in UI how I can do that

[ajaykakkar93]

Hi,

While loading fields you can add another field on all qvds & then concat them together

Example

T1:

Load * ,

'table1' as TXn

From lib://.....qvd;

Concatenate(T1)

T2:

Load * ,

'table2' as TXn

From lib://.....qvd;

Concatenate(T1)

T3:

Load * ,

'table3' as TXn

From lib://.....qvd;

You will get a single table

Then in set analysis you can specify the specific tXn field value.

[_armoco_]

Hi,

You mentioned want to separate the 'date' or is it 'Data'...?

If I understand correct, then your data is getting auto concatenated as all the tables have same fields. You can separate it by forcing a 'Noconcatenate' but this will create a synthetic key issue. So instead create a flag field in all 3 loads:

A:

load

..., ...,...,'A' as Flag,...etc

from....;

B:

load

..., ...,...,'B' as Flag,...etc

from....;

C:

load

..., ...,...,'C' as Flag,...etc

from....;

Now in the front end you can use the flag to differentiate between data

Ex: Sum({<Flag={'A'}>}Amt)  //This will give data of Qty of table A as Flag A is created for table A

Sum({<Flag={'C'}>}Amt)  //This will give data of Qty of table C as Flag C is created for table C

Similarly, you can use it in if conditions too...

Regards,

Arjun

[ajaykakkar93]

Yes