can anyone help me with this?
CrossTable(Store,4)
[XXX1]:
LOAD distinct
TEST1203,
TEST120,
FROMDT,
UPTODT,
DT,
PRODUCT,
TEST16,
PRICE,
WAC,
REFERENCE,
TEST34,
TEST12,
"DIV",
TEST13,
TEST6,
TEST4,
TEST1,
TEST2,
TEST3,
TEST4,
BRAND,
BRANDNAME,
Name1,Name2,Name3,Name4,Name5,Name6,Name7,Name8,Name9,Name10,Name11,Name12,Name13,Name14,Name15
FROM [lib://QVDs (winserver2019_administrator)/XXX1.qvd](qvd) where 1=1;
STORE [XXX1] INTO 'lib://QVDs (winserver2019_administrator)/XXX.qvd' (qvd);
DROP TABLE [XXX1];
i want Name1,2,3 to be in a filed called Store a new filed in this called store insted of name name name name i want all of them to be in the store.
