I have a table with numbers like this
LOAD * INLINE [
When I executed the script, as the result I have only one row - 9966. But I still need both values. What can I do, to keep them both at the result?
Solved! Go to Solution.
You still got two rows, but with identical values. Try to calculate count(F1), it should be equal to 2.
Try this to fix your issue:
LOAD text(F1) as F1 INLINE [