Hi
I need help.
I have a CSV file that will be uploaded regularly which contains the Year column in number type. In the app Year is an Enum Number data type. But by doing this thousand separated comma is automatically added.
Is there a way to go about this without changing the data type to text in CSV or in the APP?
Solved! Go to Solution.
I found a solution for this. Writing the solution for others to see.
Add a new table with the ID as list of year.
Use Enum and Base type make it Ref and reference the year table. This solves the issue.
User | Count |
---|---|
36 | |
9 | |
3 | |
3 | |
2 |