Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have this script:
I have same field names and I get AT.make and BE.make, but I just need "make" to be global, I think I can do this with Dealer as the primary key. I've tried "Concat(table_1, '-', dealer) as PrimaryKey2" but this just gives me an error that table_1 does not exist.
table_1:
LOAD
ID,
Country,
make,
dealer,
daysOnline,
FROM [lib://AttachedFiles/all.xlsx]
(ooxml, embedded labels, table is AT);
Table2:
LOAD
ID,
Country,
make,
dealer,
daysOnline,
FROM [lib://AttachedFiles/all.xlsx]
(ooxml, embedded labels, table is BE);
Any tips?
Hi,
Use concatenate
table_1:
LOAD
ID,
Country,
make,
dealer,
daysOnline,
FROM [lib://AttachedFiles/all.xlsx]
(ooxml, embedded labels, table is AT);
Concatenate(table_1)
LOAD
ID,
Country,
make,
dealer,
daysOnline,
FROM [lib://AttachedFiles/all.xlsx]
(ooxml, embedded labels, table is BE);
Thanks
Vikas
Is table1 is subset of Table2?
Hi,
Use concatenate
table_1:
LOAD
ID,
Country,
make,
dealer,
daysOnline,
FROM [lib://AttachedFiles/all.xlsx]
(ooxml, embedded labels, table is AT);
Concatenate(table_1)
LOAD
ID,
Country,
make,
dealer,
daysOnline,
FROM [lib://AttachedFiles/all.xlsx]
(ooxml, embedded labels, table is BE);
Thanks
Vikas
I get duplicate values tho now.. why?
@Nolgath , try Load distinct .