Adding a caluclated field while loading a file

[alec1982]

Hi,

I am loading a table with from a file where i have one field with text values in it such as Month, Quarter, Year.

I am trying to calcluate a new field to show Value in nrs as follow

Name     Field A     Calculated Field

X            Monthly    12

Y            Quarter     4

Z             Year         1

My way of thinking to to have an if statement to create the field ...something like:

If Name = Monthly then 12

if Name = Quarter then 4

if name = year then 1

end as Frequency

I appreciate any help.

Thxs,

[mphekin12 · Accepted solution]

Something like this may work for you:

if(Name='X',12,
      if(Name='Y',4,
            if(Name='Z',1,0)
      )
) as Frequency

or

if([Field A]='Monthly',12,
       if([Field A]='Quarter',4,
           if([Field A]='Year',1,0)
      )
) as Frequency

[alec1982]

That's excactly what I am looking for!

Thxs,