Forum Discussion

i_kafali's avatar
i_kafali
Icon for Helper II rankHelper II
8 years ago

SELECTCOLUMNS does not return correct values from existing table

Hello,   I have an existing table called OK_INVOICE_ALL_EXCEL. so i have created new table called PARETO to make more lean table.   To create PARETO table i used below formula   PARETO = SELECT...
Need Help
Show and Tell
Tips and Tricks
tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
8 years ago
PARETO = SELECTCOLUMNS(OK_INVOICE_ALL_EXCEL;
"currency";OK_INVOICE_ALL_EXCEL[Currency Selection];
"year";OK_INVOICE_ALL_EXCEL[Only Year];
"month";OK_INVOICE_ALL_EXCEL[MONTH];
"scenario";OK_INVOICE_ALL_EXCEL[Fiili/Bütçe];
"entity";OK_INVOICE_ALL_EXCEL[FIRMA];
"seller";OK_INVOICE_ALL_EXCEL[SAT_AD];
"customer no";OK_INVOICE_ALL_EXCEL[CUSTOMER_NO];
"customer";OK_INVOICE_ALL_EXCEL[MUS_AD];
"product";OK_INVOICE_ALL_EXCEL[DESCRIPTION];
"BU";OK_INVOICE_ALL_EXCEL[BU];
"volume (ton)";[Volume (ton)];
"Turnover";[TurnoverPV];
"FP1";[FP1];
"FP2";[FP2]
)

Does all columns produce inconsistant values or can you see any pattern?