Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
can anyone please tell me why i get NULL's for this script:
Table:
LOAD * INLINE [
Id, Upgrade, Date
123, Base, 1
123, TTR, 1
456, TTR, 3
];
TableBase:
LOAD Id, Date, Upgrade as [Basic Upgrade]
Resident Table
WHERE Upgrade='Base';
Dear,
You didn't drop the table.
your script should be like below.
Table:
LOAD * INLINE [
Id, Upgrade, Date
123, Base, 1
123, TTR, 1
456, TTR, 3
];
TableBase:
LOAD Id, Date, Upgrade as [Basic Upgrade]
Resident Table
WHERE Upgrade='Base';
DROP Table Table;
Dear,
You didn't drop the table.
your script should be like below.
Table:
LOAD * INLINE [
Id, Upgrade, Date
123, Base, 1
123, TTR, 1
456, TTR, 3
];
TableBase:
LOAD Id, Date, Upgrade as [Basic Upgrade]
Resident Table
WHERE Upgrade='Base';
DROP Table Table;
your script is concatenated your table,your output table is like below
Id | Date | Basic Upgrade |
---|---|---|
123 | 1 | Base |
456 | 3 |
because both table has same field except Basic Upgrade.
try to use following script
Table:
LOAD * INLINE [
Id, Upgrade, Date
123, Base, 1
123, TTR, 1
456, TTR, 3
];
noconcatenate // it will separate the table fileds
TableBase:
LOAD Id, Date, Upgrade as [Basic Upgrade]
Resident Table
WHERE Upgrade='Base';
drop table Table;
The Table Viewer (Ctrl-T or icon on the right of the Design-toolbar) is your friend here.
Good luck,
Peter