This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have been facing this issue for long time. I am getting API data and its always the case where they +-2 columns and when I try to marry all these files together it’s just not happening. Basically, I just want to add to formula or something where it will dynamically add additional columns even if that columns has no value. Just so that when I merge all these different from same API it can be done quickly without me going selecting every single file and then using union tool.
One file has column names as type 1, 2 ,3 and other file has type 1,2,3,4,5,6,7,8,9 and other has type 1,2,3,4.
Just if they all have max columns till type 9 as column in the file even if its empty would be great. Thank you in advance and really appreciate your time
I've attached an example that uses a text input tool (annotated Master) that contains all the columns you will need for all inputs. You will want to attach that text input to the union first so that it uses it's column names as the output. Follow this up with attaching the 3 other input files with data.