Dear Ali,
In my original table i have a lot of different names as headers, for example 088888 659 Q.
When i try to adapt your code into my original table i am getting the following error:
DataFormat.Error: We couldn't convert to Number.
Details:
659 Q
If i remove that column, i am getting the same error for another column, for example 075426 123 M
Any ideea why is this happening?
EDIT1:
I tried to change Int64.Type to Text.Type, just for fun...
I don't have any error now, but it only imports 92 row, instead of 177...
EDIT2:
i just realized that part of my table is not finished yet, so it contains no data yet. So i replace null with 0 in PQ and now i think that it imports all rows.
I must see how can i change the code, in order to not sort column a from smallest to greatest.
When you have time, please let me know if the changes i made are ok or are just silly
Bookmarks