Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have my Script with an INLINE table for field ID with values:
000
005
020
035
Then I have my Fact Table with the ID and other fields.
The thing is that I need to get the IDs STARTING with the values from INLINE.
For example, IDs: 000835, 005358, etcetera.
Is there any way to do this in the WHERE clause from the Fact Table?
(If I make a Where Exists(ID) in the Fact Table, I'd only get values 000, 005, 020 and 035)
Thank you!
Temp:
Load Num#(ID,'000') as ID INLINE
[
ID
000
005
020
035
];
Sales:
Load
CustomerID,
Sales
Where Exists (ID, ID1);
Load
Num#(CustomerID,'000000') as CustomerID,
Num#(Left(Num#(CustomerID,'000000'),3),'000') as ID1,
Sales
Inline
[
CustomerID, Sales
000835, 100
000122, 120
005140, 200
001256, 100
];