Relations without duplicate

[Anonymous]

How can I make relations between [date] and [user ID] without duplicate in data

Regards

[pokassov · Accepted solution]

Hello!

Concatenate all tables?

[Anonymous]

Its look like all the tables have same records...simple solution is. Concatenate All and maintain a flag for each table,

also make sure while concatenating all the tables have same field name, rename all the fields of table

like:

Load

*,

Date01 as Date,  //repeat for all fields

'Hed' as Flag

from Inthed;

concatenate

Load

*,

Date02 as Date,   //repeat for all fields

'Hed1' as Flag

from Inthed1;

and so on..

[tresesco]

Concatenate them with a flag field additionally, like:

Load    

          User_ID,

          Memo01 as Memo,

          Date01 as Date,

...,

          'Source1' as Flag

From   <Source1>;

Load    

          User_ID,

          Memo02 as Memo,

          Date02 as Date,

...,

           'Source2' as Flag

From   <Source2>;

......;

Then use this flag field in the front-end expression (wherever you need to seperate out) like: =Sum({<Flag={'Source1'}>} Amountfield), or so.

[Kushal_Chawda]

You can Concatenate all the tables

for eg

InvHed:

Load UserID,

        Date01 as Date

        Memo01 as Memo,

     'InvHed' as Flag,

  .

  .

  .

From InvHed

concatenate

InvHed:

Load UserID,

        Date02 as Date

        Memo02 as Memo,

     'InvHed1' as Flag,

  .

  .

  .

From InvHed1

likewise you can concatenate all the tables

[Anonymous]

Thanks all