if statement to change field name

[jleefjcapital]

I'm using this IF statement to change the field name on condition of another field value.

If([seriesID] = 'SMS01000000000000001', [value]) as [Alabama]

So basically, I am looking to create another field called [Alabama] using data points from [value] when [seriesID] = 'SMS01000000000000001'.

This code does not work in its current form.

[sunny_talwar]

Can you share screenshots of a table which include seriesID, value and Alabama?

[jleefjcapital]

I'm providing a screenshot of Date, SeriesID, and Value.  I was not able to rename the Value field to Alabama. 

[jleefjcapital]

[jleefjcapital]

[sunny_talwar]

You will need to create a table instead of individual filters. I want to see how they look in a single row.

[jleefjcapital]

Here you go.  I think one issue is, the data are monthly, and the dates are showing up as daily so there are many nulls.

[sunny_talwar]

So my question to you is.... If you now create this field called Alabama

If([seriesID] = 'SMS01000000000000001', [value]) as [Alabama]

If won't show value for these rows?

[jleefjcapital]

Yes.  It creates a separate field, but there's no data associated with it. 

[sunny_talwar]

Can you add the image of the fourth column added to your table? Also can you share the complete script where you are doing this?