https://community.databricks.com/t5/data-engineering/trying-to-write-my-dataframe-out-as-a-tab-separated-txt-file-but/m-p/18658#M12415 <P>When I try to save my file I get</P><P></P><P>org.apache.spark.sql.AnalysisException: Text data source supports only a single column, and you have 2 columns.;</P><P></P><P> Is there any way to save a dataframe with more than one column to a .txt file?</P> Fri, 25 Jun 2021 21:10:37 GMT User16826992666 2021-06-25T21:10:37Z https://community.databricks.com/t5/data-engineering/trying-to-write-my-dataframe-out-as-a-tab-separated-txt-file-but/m-p/18658#M12415 <P>When I try to save my file I get</P><P></P><P>org.apache.spark.sql.AnalysisException: Text data source supports only a single column, and you have 2 columns.;</P><P></P><P> Is there any way to save a dataframe with more than one column to a .txt file?</P> Fri, 25 Jun 2021 21:10:37 GMT https://community.databricks.com/t5/data-engineering/trying-to-write-my-dataframe-out-as-a-tab-separated-txt-file-but/m-p/18658#M12415 User16826992666 2021-06-25T21:10:37Z https://community.databricks.com/t5/data-engineering/trying-to-write-my-dataframe-out-as-a-tab-separated-txt-file-but/m-p/18659#M12416 <P>Would <A href="https://spark.apache.org/docs/latest/api/python/reference/api/pyspark.sql.DataFrameWriter.csv.html#pyspark.sql.DataFrameWriter.csv" alt="https://spark.apache.org/docs/latest/api/python/reference/api/pyspark.sql.DataFrameWriter.csv.html#pyspark.sql.DataFrameWriter.csv" target="_blank">pyspark.sql.DataFrameWriter.csv</A> work? You could specify the separator (sep) as tab</P><P></P><PRE><CODE>df.write.csv(os.path.join(tempfile.mkdtemp(), 'data'))</CODE></PRE><P></P> Fri, 25 Jun 2021 21:45:01 GMT https://community.databricks.com/t5/data-engineering/trying-to-write-my-dataframe-out-as-a-tab-separated-txt-file-but/m-p/18659#M12416 sajith_appukutt 2021-06-25T21:45:01Z