Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

tables

I am concatenating the 2 tables into 1 table , now i want to identify the records from each tables respectively ??? how can i do that plz help ??? may be i can use flag ....... not sure ......

1 Solution

Accepted Solutions
jvitantonio
Luminary Alumni
Luminary Alumni

Yes, you can use a flag. Like this:

load fieldA, fieldB, 'table1' as flag FROM yourtable;

CONCATENATE

LOAD fieldC, fieldY, 'table2' as flag FROM yourOtherTable;

View solution in original post

4 Replies
jvitantonio
Luminary Alumni
Luminary Alumni

Yes, you can use a flag. Like this:

load fieldA, fieldB, 'table1' as flag FROM yourtable;

CONCATENATE

LOAD fieldC, fieldY, 'table2' as flag FROM yourOtherTable;

Not applicable
Author

hi manish,

ok you are concatinating two tables since most of the fields are

simillar right , yes go on know the problem is you need to identify the records of

two tables for this use flag yes u are right just see how to do this

Sales_ Header:

ItemNo

Documentno

Quantity as SalesHeader_Qty,

'Header' as Flag

concatenate

ItemNo

Documentno

Quantity as SalesLine_Qty,

'Line' as Flag

Warm Regards,

Anant Dubey

Not applicable
Author

I have a field as Employee No it contain data from both the tables , now i want to count the employee no depending upon the flag value ???????

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

Then use that flag in Set analysis.

Count({<Flag={0}>} Distinct EmployeeNo)

Celambarasan