Hi All,
I am trying to prepare a JSON data using the following workflow
But cross tab is giving me some unwanted fields like shown below
Can you please help me understand why these files are being created?
Hi Adij,
These columns are being generated because they're part of the JSON output you're download.
I don't know exactly what you're downloading, but it looks like some system details are being given in your output.
Like Marquee says you could filter them out before cross-tabbing your data by filtering out anything that contains resourceRequests_
Okay. How would I do that? What expression should I use? I am very new to Alteryx.
I'm having this same issue that is causing an issue with bulk loading process. Null dates are being converted to empty dates after passing through a crosstab. Empty dates cause an error when being bulk loaded into Date columns. I need to check all columns for any non-UTC-8 characters so I Transpose -> Regex --> Crosstab to put the record back together. Any columns with null values get transformed to empty by the Crosstab. Since this is in a macro the date columns could anywhere. Seeking a solution.
