Create a list of values variable for the usage in a SQL Where IN-Clause.
Companies: | |
LOAD * INLINE [ | |
Company | |
CompanyA | |
CompanyB | |
CompanyC | |
]; | |
List: | |
LOAD | |
concat(Company,chr(39)&','&chr(39)) as AllCompanies | |
resident Companies; | |
LET vList = chr(39)& peek('AllCompanies') & chr(39); | |
// Sample SQL Select Statement: | |
SQL SELECT * FROM company WHERE name IN ($(vList)); |
This comment has been minimized.
This comment has been minimized.
Well, FieldValue() shouldn't be faster or better in this case of one row.. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
This comment has been minimized.
Alternative to peek:
LET vList = FieldValue('AllCompanies', 1);
Thanks!