Re: Putting CSV data into a chart & other questions - KX Learning Hub

biggorilla

Member
April 16, 2022 at 12:00 am
Hi Leah S!

I’m using Dashboards. I don’t know whether that’s Direct or not.

I have been able to make some progress with:
```
myCSV:("PFFFFF";enlist csv) 0: `$":/q/spy.csv"


c:myCSV[`Line] where myCSV[`Line] <> 0

close:myCSV[`close] where myCSV[`Line] <> 0


dc:deltas c

dclose:deltas close


dc2:dc[1+til 6669]

dclose2:dclose[1+til 6669]
```
This takes the data I want; two columns and only where both contain the data I want. However, I haven’t figured out how to access these data in Dashboards.

I tried to save them to csv files using the ‘set’ function, but the files are corrupt. Using ‘Save’ gave a ‘mismatched type’ error. I was trying to do this because I know how to use them. I have been trying out this code in Developer.

I tried to put the above code into one line in an attempt to use the data in Dashboards, but couldn’t figure it out. I’m not sure if that’s the right next step.