Excel Pivot Table - Syntax for Field

Hi,

what is the syntax for Field:

Thx and KR,
Vanja

Hi @VanjaV

In the field “NameofYourColumn”

You just have to mention in double quotes name of the column.

Hope this helps :slight_smile:

1 Like

Example-

1 Like

image

Hi @VanjaV

You have to mention the range in source.
Excel.Sheet(“Tabelle1”).Range(“C6:N100”) like this so that all the column names will appear. You can click on plus symbol to configure it, it will give you options.

Hope this helps:)

1 Like

Hey @VanjaV take a look in your Create pivot Activity you select the range “C6” and your column is in “N” so you have to increase your range.


you select C6 thats why bot could not find the Column12 which is in N column

cheers

1 Like

Hey @AJ_Ask yes this could be the method but suppose if after N100 in the near future the data is got updated in 101 than it colud be a problem so @VanjaV make it more dynamic ,

cheers

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.