Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How should I do to only load the row´s that have the combination of A4 and 80g?
In this exampel I would like to get row no 1, 2, 3, 4, but not row 5 because row 5 are A4 and 100g.
I did a test with crosstable to get all the "Kolumn"-data to a single field. But from there I got stuck.
Try,
Test:
LOAD RowNo,
Artikelnr,
Kolumn13,
Kolumn12,
Kolumn11,
Kvantitet
FROM
Paper.xlsx
(ooxml, embedded labels, table is Blad1)
Where Wildmatch(Kolumn13&Kolumn12&Kolumn11,'*A4*80g*','*80g*A4*');
Row 1 is not a combination of A4 and 80g. Let me know.
Try,
Test:
LOAD RowNo,
Artikelnr,
Kolumn13,
Kolumn12,
Kolumn11,
Kvantitet
FROM
Paper.xlsx
(ooxml, embedded labels, table is Blad1)
Where Wildmatch(Kolumn13&Kolumn12&Kolumn11,'*A4*80g*','*80g*A4*');
Row 1 is not a combination of A4 and 80g. Let me know.
Thanks so much. And of course you are right in that row 1 is not a correct value