0

Merging columns same data source, different sheets

Denis Galvão

August 02, 2018 22:01

None

Follow

I did use ARRAY function:

ARRAY(@Julho2018,B:B;,@Agosto2018,B:B;)

Using the same data source but different sheets, only shows me Julho2018.B;B.

Denis.

 

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Rahul Bura August 03, 2018 13:54

  Hey Denis,

  Thanks for reaching out! :) If you are looking to combine data from two sheets from the same column, ARRAY is indeed the way to go and it looks to be correct. A quick test would be to evaluate @Julho2018,B:B; and @Agosto2018,B:B; individually to ensure they both have values and if so, how many entries. Then when you evaluate the ARRAY, you should see the total number of entries - this should be the sum of the number of entries for each @Julho2018,B:B; and @Agosto2018,B:B; respectively. 

  If when evaluating @Julho2018,B:B; and @Agosto2018,B:B; respectively you notice that @Agosto2018,B:B doesn't have values, then what you are currently seeing would be correct.

  If you need us to take a closer look, I would suggest submitting a support ticket and letting us know the name of the klip and component and we can take a closer look here Denis.