Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
this is hopefully a very simple one but has me stupmed. When i load the below i keep getting field names must be uniqe and it wont transform cy01 to cy12... i am trying to get them all into one column but have so far failed... any ideas?
Directory;
CrossTable(cross_selling_key, Data, 4)
LOAD Financial_Line,
cross_selling_key,
PYFY,
YTD3,
CY01,
CY02,
CY03,
CY04,
CY05,
CY06,
CY07,
CY08,
CY09,
CY10,
CY11,
CY12
FROM
[Copy of Book1.xlsx]
(ooxml, embedded labels, table is Sheet1);
ta
great thanks.... although another question that comes off the back of this i need to put an if statment in as for PYFY and YTD3 i want the number to be 0 for for CY01, CY02 ect, only where it is CY12 do i want the value that should be there., any ideas on what the if statment should be on the transform?
Hi,
when your doing scripting that time you can change the field name,it will be work fine,
do one thing change field name at script
CrossTable(cross_selling_key, Data, 4) rename it as CrossTable(key,Data,4) it will be work.
Regards
Hi,
it is possible to get a sample data.
Regards
great thanks.... although another question that comes off the back of this i need to put an if statment in as for PYFY and YTD3 i want the number to be 0 for for CY01, CY02 ect, only where it is CY12 do i want the value that should be there., any ideas on what the if statment should be on the transform?
great thanks.... although another question that comes off the back of this i need to put an if statment in as for PYFY and YTD3 i want the number to be 0 for for CY01, CY02 ect, only where it is CY12 do i want the value that should be there., any ideas on what the if statment should be on the transform?
data is as below, the actaully file is 500k lines long, but get it working on 1 line it will work on them all
Financial_Line | cross_selling_key | PYFY | YTD3 | CY01 | CY02 | CY03 | CY04 | CY05 | CY06 | CY07 | CY08 | CY09 | CY10 | CY11 | CY12 |
Other Operating Income | CASH | 1554.59 | 1293.63 | 3.35 | 61.98 | 64.14 | 62.76 | 178.63 | 91.36 | 136.52 | 188.78 | 59.56 | 187.97 | 151.87 | 106.71 |
Hi,
Please fiend the attachment of application.
Regards
not quite, i would like the output to look like the below if it is in a straight table.
if possible can you pos the code rather than send an example as ihavent switched my license over to this machine yet.
Financial_Line | cross_selling_key | date | Amount | PYFY | YTD3 |
Other Operating Income | CASH | CY01 | 3.35 | 0 | 0 |
Other Operating Income | CASH | CY02 | 61.98 | 0 | 0 |
Other Operating Income | CASH | CY03 | 64.14 | 0 | 0 |
Other Operating Income | CASH | CY04 | 62.76 | 0 | 0 |
Other Operating Income | CASH | CY05 | 178.63 | 0 | 0 |
Other Operating Income | CASH | CY06 | 91.36 | 0 | 0 |
Other Operating Income | CASH | CY07 | 136.52 | 0 | 0 |
Other Operating Income | CASH | CY08 | 188.78 | 0 | 0 |
Other Operating Income | CASH | CY09 | 59.56 | 0 | 0 |
Other Operating Income | CASH | CY10 | 187.97 | 0 | 0 |
Other Operating Income | CASH | CY11 | 151.87 | 0 | 0 |
Other Operating Income | CASH | CY12 | 106.71 | 1554.6 | 1293.6 |