Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ......
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;
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;
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
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 ???????
Hi,
Then use that flag in Set analysis.
Count({<Flag={0}>} Distinct EmployeeNo)
Celambarasan