Renaming fields in an Inline statment

[#1]

Hi there guys.

I have created the attached dynamic table and I am interested in changing the name of the fields shown on the "choose a parameter" list box.

These fields are defined in the inline table called [_Dimension]. For some reason the "as" syntax doesn't work in the script

I have read some info about the mapping syntax but couldn't realize if its relevant for this case (and how does it work as well.. )

Can anyone give me a solution for that?

Thanks in advance.

[giakoum]

Hope this helps

[#3]

Thanks a lot Loannis for the quick reply..

Your solution did not answer fully to the problem since the new aliases did not affect the dynamic table, i. e., once choosing one of the new aliases you made, one could not see them reflecting on the dynamic table.

I need to see the fields I'm selecting in the dynamic table as well. prior to the name change it worked perfectly.

[brenner_martina · Accepted solution]

Hi,

the easiest way to do this even with entering functions:

Data:
LOAD Customername As Customer,
  Salesvalue As Sales,
  OrderdateSales As Date,
  Year(OrderdateSales) As Orderyear,
  Month(OrderdateSales) As Ordermonth 

INLINE [
    Customername, Salesvalue, OrderdateSales
    A, 120, 12.7.2012
    B, 200, 2.5.2012
    C, 250, 17.2.2012
];

Greetings from Munich

Martina

[#5]

Dear Dear Martina..

Your solution took me a while to sort, but once defined correctly, it made wonders.

so therefor I can define your solution as a "sehr gutte" one!

Vielen Dank!

Evya