Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can you share screenshots of a table which include seriesID, value and Alabama?
I'm providing a screenshot of Date, SeriesID, and Value. I was not able to rename the Value field to Alabama.
You will need to create a table instead of individual filters. I want to see how they look in a single row.
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.
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?
Yes. It creates a separate field, but there's no data associated with it.
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?